﻿CREATE PROCEDURE [dbo].[GetMediaStockById] 
	@MediaStockId int
AS
BEGIN

	SELECT Stock.StockId, Code, [Description], [Weight], SizeX, SizeY, Facing, Colour, Stock.StockTypeId, StockType, MediaStockId, MediaDefId, PublishDate, StationNumber
	FROM dbo.MediaStock
	INNER JOIN dbo.Stock ON MediaStock.StockID = Stock.StockID
	INNER JOIN dbo.StockType ON StockType.StockTypeID = Stock.StockTypeID
	WHERE MediaStockId = @MediaStockId

END